package com.wzdigit.wms.basic.mapper.core.basic;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.wzdigit.framework.orm.mybatis.MyBatisRepository;
import com.wzdigit.wms.basic.client.response.report.SaleInvReportReponse;
import org.apache.ibatis.annotations.Param;

import java.math.BigDecimal;

/**
 * 库存库位接口 Mapper
 * Created by zyf on 2021/4/30 9:20
 */
@MyBatisRepository
public interface InvLotMapper  extends BaseMapper<SaleInvReportReponse> {
    //根据lotno查询库存数量
    BigDecimal selectInvQty(String lotno);

    //根据lotno查询封位库存数量
    BigDecimal selectFreezeInvQty(String lotno);

    //根据lotno和QA_Status计算库存数量
    BigDecimal selectInvQtyByLotnoAndStatus(@Param("lotno") String lotno,@Param("status") Integer status);
}
